UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fI8ubMeZMyoCdxCgqihgx7eDAd4+5aty9NakC48e76U='
WHERE
key_id = '1c49bf40e4dd2860aa5de3d393387f162012fff3860288b192f487bb4732b992'
AND (
token = 'fI8ubMeZMyoCdxCgqihgx7eDAd4+5aty9NakC48e76U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)