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