UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/rexo4WOfRyuRwlOD451KAH83qN24HI8noa3einQ358='
WHERE
key_id = '4292182a2961b2939c504067ed6d13cff83be9a44513ef5a6eeea2f9360a3431'
AND (
token = '/rexo4WOfRyuRwlOD451KAH83qN24HI8noa3einQ358='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)