UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cJXPAjhGwsyfOnjVP8ZCRItsmN2PvpvyzeMisDA2OlE='
WHERE
key_id = '4e3037c36d5fb08ad553f5647192183601e88f7be7bacf74db2b3eac9edc90f1'
AND (
token = 'cJXPAjhGwsyfOnjVP8ZCRItsmN2PvpvyzeMisDA2OlE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)