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