UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/XLsa7XCjHWyxwFshbTZj4z/rr2O9Ah4E00bY/ZRNtA='
WHERE
key_id = '9f9dc1279131d2a202e25eb37ed0d9d168322d23700fdc6006e3e31d356dd91a'
AND (
token = '/XLsa7XCjHWyxwFshbTZj4z/rr2O9Ah4E00bY/ZRNtA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)