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