UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QJgN3shbYxhtll1x2hwy79VBJ2U5op7sU4BnfmIjxDU='
WHERE
key_id = '3b1d4c5ffe74e7308cb18d80bbb1706bbc5a0b422165b6ae9390d80a81d69e0f'
AND (
token = 'QJgN3shbYxhtll1x2hwy79VBJ2U5op7sU4BnfmIjxDU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)