UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HzjPNA9W0sI9N0ah29VoCwxPe5LLVqvjZWvQdBD6OLg='
WHERE
key_id = '66d780b453ec68f9e6e63861b17406f56efd78880c7325716173d1401580bf7b'
AND (
token = 'HzjPNA9W0sI9N0ah29VoCwxPe5LLVqvjZWvQdBD6OLg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)