UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AD3cQ/4mcFJI960+2d1YL6mi7/0rlinZsyjOfPzCioQ='
WHERE
key_id = '8b07ec9471474ee6c27ab2fbef0d660c632299641b76f011bf207473a13cdfa2'
AND (
token = 'AD3cQ/4mcFJI960+2d1YL6mi7/0rlinZsyjOfPzCioQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)