UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X2z4FGzUwH01J8DyStCB65D9xI4d0hP4vC7jhDWrmpM='
WHERE
key_id = '31f63bb3acac194620d3d975d4299fa5474a83ac1dc97dd296b1cb7b4eb2db70'
AND (
token = 'X2z4FGzUwH01J8DyStCB65D9xI4d0hP4vC7jhDWrmpM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)