UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/y0MMIukkijzCfolP3fHLXSLgP9Yo42mRnt65xQKCyI='
WHERE
key_id = '627c8f786ba707fc744b7760e092f718286492de8ce3556b18e3f3911c3a54cc'
AND (
token = '/y0MMIukkijzCfolP3fHLXSLgP9Yo42mRnt65xQKCyI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)