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