UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'trMNofWdaIv780GDR+5RBNlklH70Kp0Wfhu3iyWLZkg='
WHERE
key_id = 'cfe29ccf99e99bf4931e4b6330e015109ba45617066bda65d3a7b747e9f0dcc4'
AND (
token = 'trMNofWdaIv780GDR+5RBNlklH70Kp0Wfhu3iyWLZkg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)