UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QjXfnO7ImyUgfWGXEmGQ/945NHhi4ghaRowjiZj2qAA='
WHERE
key_id = '7e99d1d42c8df26043af097500d0c040c27ccd6a867d8dcac526840bd7e7566c'
AND (
token = 'QjXfnO7ImyUgfWGXEmGQ/945NHhi4ghaRowjiZj2qAA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)