UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pzk3l8IUyH14oud5/QZmB40fijmcP/aK0F/mo8autHg='
WHERE
key_id = 'e0e8cc248833c8979a296b422f0755fad690e00e45e9cb90eb362fa743e4e944'
AND (
token = 'pzk3l8IUyH14oud5/QZmB40fijmcP/aK0F/mo8autHg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)