UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WAL/9df8GkQR4WuowuGNmVW1Q8RK05crVxrxf1EPTkY='
WHERE
key_id = 'b8f0bc94c9363563b3af87eb48f427d7eee38b0f2e8369dd3ccd6cf4eb8b1ce4'
AND (
token = 'WAL/9df8GkQR4WuowuGNmVW1Q8RK05crVxrxf1EPTkY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)