UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9oR/mgtDEVk/tZa1yfs/weXeCOy5z6p62JyoCB9LJGY='
WHERE
key_id = '9c8caa73e189fb9fbedd41c08043aaa4dd518d161e011e327a99878f4602f964'
AND (
token = '9oR/mgtDEVk/tZa1yfs/weXeCOy5z6p62JyoCB9LJGY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)