UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4IZMTJuGdI7Df0b+1pldQn5iPKr8HnGrYbCT0v8veaM='
WHERE
key_id = '7abc205444d6070248b23b953e55b94b39d0a583debba7ba55fbfcee29f6c936'
AND (
token = '4IZMTJuGdI7Df0b+1pldQn5iPKr8HnGrYbCT0v8veaM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)