UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DYPt6xHGey18e//muPwMH8sOGOh/Zev0AD3df3AdjIA='
WHERE
key_id = 'f1ff8480deeb0153684a712e1f348f22ed1f7bb556c5857b0fba41ed4c3ad165'
AND (
token = 'DYPt6xHGey18e//muPwMH8sOGOh/Zev0AD3df3AdjIA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)