UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xlRqZg0c6+E7w5MmirmwbFrAlNAXmfsyrHL+BE/yMT0='
WHERE
key_id = '227530b5a455133d5d8b86a7731574810202becf6f8e24d9fdb694542e147985'
AND (
token = 'xlRqZg0c6+E7w5MmirmwbFrAlNAXmfsyrHL+BE/yMT0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)