UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bZcbaUNyHMaARr0JYeoLykdZu53k2lvyVDP/1iWTt6g='
WHERE
key_id = 'b2d0642ad21320ea7e31d5071cd780f7a7d1d4f8a9580262a7e2403618a1284b'
AND (
token = 'bZcbaUNyHMaARr0JYeoLykdZu53k2lvyVDP/1iWTt6g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)