UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nirF9KXN1jWql15H+j1k97yNDdr+2eD0vfCOFGEF47E='
WHERE
key_id = '567b6e722f630561ef8ff24fdcfda6ac25e3ae9f4bbabdb5721514e33e5caf94'
AND (
token = 'nirF9KXN1jWql15H+j1k97yNDdr+2eD0vfCOFGEF47E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)