UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zkB1piMdqo0A2koGr0aJYzhFdxKEpbVMQn6foTt134s='
WHERE
key_id = 'c6a52ca0a9ab5f1bb05ae7d058f2ca4eb1d05858b4b89b341fe229e95b1a78cd'
AND (
token = 'zkB1piMdqo0A2koGr0aJYzhFdxKEpbVMQn6foTt134s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)