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