UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QkCUHz4YilGctGWOj2DskvstnnEb6mkFZbBb+8l9xcw='
WHERE
key_id = 'db39a2a9ffdcc60477a0945e44da0d87df018b54cbadb4dc80d3116aaa86f738'
AND (
token = 'QkCUHz4YilGctGWOj2DskvstnnEb6mkFZbBb+8l9xcw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)